/*
 Navicat Premium Data Transfer

 Source Server         : localMariDB
 Source Server Type    : MariaDB
 Source Server Version : 100214
 Source Host           : localhost:3306
 Source Schema         : laraveladmin55

 Target Server Type    : MariaDB
 Target Server Version : 100214
 File Encoding         : 65001

 Date: 29/07/2018 16:01:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin_config
-- ----------------------------
DROP TABLE IF EXISTS `admin_config`;
CREATE TABLE `admin_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_config_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_menu`;
CREATE TABLE `admin_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `order` int(11) NOT NULL DEFAULT 0,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uri` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_menu
-- ----------------------------
BEGIN;
INSERT INTO `admin_menu` VALUES (1, 0, 1, '仪表盘', 'fa-bar-chart', '/', NULL, '2018-07-29 15:50:45');
INSERT INTO `admin_menu` VALUES (2, 0, 2, '系统管理', 'fa-tasks', NULL, NULL, '2018-07-29 15:50:22');
INSERT INTO `admin_menu` VALUES (3, 2, 3, 'Users', 'fa-users', 'auth/users', NULL, NULL);
INSERT INTO `admin_menu` VALUES (4, 2, 4, 'Roles', 'fa-user', 'auth/roles', NULL, NULL);
INSERT INTO `admin_menu` VALUES (5, 2, 5, 'Permission', 'fa-ban', 'auth/permissions', NULL, NULL);
INSERT INTO `admin_menu` VALUES (6, 2, 6, 'Menu', 'fa-bars', 'auth/menu', NULL, NULL);
INSERT INTO `admin_menu` VALUES (7, 2, 7, 'Operation log', 'fa-history', 'auth/logs', NULL, NULL);
INSERT INTO `admin_menu` VALUES (8, 0, 8, '设置', 'fa-toggle-on', 'config', '2018-07-29 15:48:38', '2018-07-29 15:50:32');
COMMIT;

-- ----------------------------
-- Table structure for admin_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_operation_log`;
CREATE TABLE `admin_operation_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `input` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `admin_operation_log_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_operation_log
-- ----------------------------
BEGIN;
INSERT INTO `admin_operation_log` VALUES (1, 1, 'huo15-admin', 'GET', '127.0.0.1', '[]', '2018-07-29 15:49:21', '2018-07-29 15:49:21');
INSERT INTO `admin_operation_log` VALUES (2, 1, 'huo15-admin/auth/menu', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2018-07-29 15:50:08', '2018-07-29 15:50:08');
INSERT INTO `admin_operation_log` VALUES (3, 1, 'huo15-admin/auth/menu/2/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2018-07-29 15:50:12', '2018-07-29 15:50:12');
INSERT INTO `admin_operation_log` VALUES (4, 1, 'huo15-admin/auth/menu/2', 'PUT', '127.0.0.1', '{\"parent_id\":\"0\",\"title\":\"\\u7cfb\\u7edf\\u7ba1\\u7406\",\"icon\":\"fa-tasks\",\"uri\":null,\"roles\":[\"1\",null],\"_token\":\"d7TFAGWDUHsfk6hvOS4iihmYDSVt27FTDOMxQGLB\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/localhost:8000\\/huo15-admin\\/auth\\/menu\"}', '2018-07-29 15:50:22', '2018-07-29 15:50:22');
INSERT INTO `admin_operation_log` VALUES (5, 1, 'huo15-admin/auth/menu', 'GET', '127.0.0.1', '[]', '2018-07-29 15:50:22', '2018-07-29 15:50:22');
INSERT INTO `admin_operation_log` VALUES (6, 1, 'huo15-admin/auth/menu/8/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2018-07-29 15:50:26', '2018-07-29 15:50:26');
INSERT INTO `admin_operation_log` VALUES (7, 1, 'huo15-admin/auth/menu/8', 'PUT', '127.0.0.1', '{\"parent_id\":\"0\",\"title\":\"\\u8bbe\\u7f6e\",\"icon\":\"fa-toggle-on\",\"uri\":\"config\",\"roles\":[null],\"_token\":\"d7TFAGWDUHsfk6hvOS4iihmYDSVt27FTDOMxQGLB\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/localhost:8000\\/huo15-admin\\/auth\\/menu\"}', '2018-07-29 15:50:32', '2018-07-29 15:50:32');
INSERT INTO `admin_operation_log` VALUES (8, 1, 'huo15-admin/auth/menu', 'GET', '127.0.0.1', '[]', '2018-07-29 15:50:32', '2018-07-29 15:50:32');
INSERT INTO `admin_operation_log` VALUES (9, 1, 'huo15-admin/auth/menu/1/edit', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2018-07-29 15:50:38', '2018-07-29 15:50:38');
INSERT INTO `admin_operation_log` VALUES (10, 1, 'huo15-admin/auth/menu/1', 'PUT', '127.0.0.1', '{\"parent_id\":\"0\",\"title\":\"\\u4eea\\u8868\\u76d8\",\"icon\":\"fa-bar-chart\",\"uri\":\"\\/\",\"roles\":[null],\"_token\":\"d7TFAGWDUHsfk6hvOS4iihmYDSVt27FTDOMxQGLB\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/localhost:8000\\/huo15-admin\\/auth\\/menu\"}', '2018-07-29 15:50:45', '2018-07-29 15:50:45');
INSERT INTO `admin_operation_log` VALUES (11, 1, 'huo15-admin/auth/menu', 'GET', '127.0.0.1', '[]', '2018-07-29 15:50:45', '2018-07-29 15:50:45');
INSERT INTO `admin_operation_log` VALUES (12, 1, 'huo15-admin', 'GET', '127.0.0.1', '[]', '2018-07-29 15:50:54', '2018-07-29 15:50:54');
INSERT INTO `admin_operation_log` VALUES (13, 1, 'huo15-admin/auth/setting', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2018-07-29 15:51:06', '2018-07-29 15:51:06');
INSERT INTO `admin_operation_log` VALUES (14, 1, 'huo15-admin/auth/setting', 'PUT', '127.0.0.1', '{\"name\":\"Administrator\",\"password\":\"$2y$10$ui14kgnlhAxtFLHNsZ.IoOsA6T6STBf15ThI8vkorC9U2Tf77GEQi\",\"password_confirmation\":\"$2y$10$ui14kgnlhAxtFLHNsZ.IoOsA6T6STBf15ThI8vkorC9U2Tf77GEQi\",\"_token\":\"d7TFAGWDUHsfk6hvOS4iihmYDSVt27FTDOMxQGLB\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/localhost:8000\\/huo15-admin\"}', '2018-07-29 15:51:29', '2018-07-29 15:51:29');
INSERT INTO `admin_operation_log` VALUES (15, 1, 'huo15-admin/auth/setting', 'GET', '127.0.0.1', '[]', '2018-07-29 15:51:30', '2018-07-29 15:51:30');
INSERT INTO `admin_operation_log` VALUES (16, 1, 'huo15-admin', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2018-07-29 15:51:34', '2018-07-29 15:51:34');
INSERT INTO `admin_operation_log` VALUES (17, 1, 'huo15-admin', 'GET', '127.0.0.1', '[]', '2018-07-29 15:51:36', '2018-07-29 15:51:36');
INSERT INTO `admin_operation_log` VALUES (18, 1, 'huo15-admin/auth/setting', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2018-07-29 15:51:45', '2018-07-29 15:51:45');
INSERT INTO `admin_operation_log` VALUES (19, 1, 'huo15-admin/auth/setting', 'GET', '127.0.0.1', '[]', '2018-07-29 15:53:14', '2018-07-29 15:53:14');
INSERT INTO `admin_operation_log` VALUES (20, 1, 'huo15-admin/auth/setting', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2018-07-29 15:53:21', '2018-07-29 15:53:21');
INSERT INTO `admin_operation_log` VALUES (21, 1, 'huo15-admin/auth/setting', 'PUT', '127.0.0.1', '{\"name\":\"Administrator\",\"password\":\"$2y$10$ui14kgnlhAxtFLHNsZ.IoOsA6T6STBf15ThI8vkorC9U2Tf77GEQi\",\"password_confirmation\":\"$2y$10$ui14kgnlhAxtFLHNsZ.IoOsA6T6STBf15ThI8vkorC9U2Tf77GEQi\",\"_token\":\"d7TFAGWDUHsfk6hvOS4iihmYDSVt27FTDOMxQGLB\",\"_method\":\"PUT\"}', '2018-07-29 15:53:29', '2018-07-29 15:53:29');
INSERT INTO `admin_operation_log` VALUES (22, 1, 'huo15-admin/auth/setting', 'GET', '127.0.0.1', '[]', '2018-07-29 15:53:29', '2018-07-29 15:53:29');
INSERT INTO `admin_operation_log` VALUES (23, 1, 'huo15-admin', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2018-07-29 15:53:33', '2018-07-29 15:53:33');
INSERT INTO `admin_operation_log` VALUES (24, 1, 'huo15-admin', 'GET', '127.0.0.1', '[]', '2018-07-29 15:53:35', '2018-07-29 15:53:35');
INSERT INTO `admin_operation_log` VALUES (25, 1, 'huo15-admin/auth/setting', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2018-07-29 15:53:52', '2018-07-29 15:53:52');
INSERT INTO `admin_operation_log` VALUES (26, 1, 'huo15-admin/auth/setting', 'PUT', '127.0.0.1', '{\"name\":\"Administrator\",\"password\":\"$2y$10$ui14kgnlhAxtFLHNsZ.IoOsA6T6STBf15ThI8vkorC9U2Tf77GEQi\",\"password_confirmation\":\"$2y$10$ui14kgnlhAxtFLHNsZ.IoOsA6T6STBf15ThI8vkorC9U2Tf77GEQi\",\"_token\":\"d7TFAGWDUHsfk6hvOS4iihmYDSVt27FTDOMxQGLB\",\"_method\":\"PUT\",\"_previous_\":\"http:\\/\\/localhost:8000\\/huo15-admin\\/\"}', '2018-07-29 15:53:58', '2018-07-29 15:53:58');
INSERT INTO `admin_operation_log` VALUES (27, 1, 'huo15-admin/auth/setting', 'GET', '127.0.0.1', '[]', '2018-07-29 15:53:58', '2018-07-29 15:53:58');
INSERT INTO `admin_operation_log` VALUES (28, 1, 'huo15-admin', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2018-07-29 15:54:02', '2018-07-29 15:54:02');
INSERT INTO `admin_operation_log` VALUES (29, 1, 'huo15-admin', 'GET', '127.0.0.1', '[]', '2018-07-29 15:54:03', '2018-07-29 15:54:03');
INSERT INTO `admin_operation_log` VALUES (30, 1, 'huo15-admin', 'GET', '127.0.0.1', '[]', '2018-07-29 15:55:22', '2018-07-29 15:55:22');
INSERT INTO `admin_operation_log` VALUES (31, 1, 'huo15-admin', 'GET', '127.0.0.1', '[]', '2018-07-29 15:58:34', '2018-07-29 15:58:34');
INSERT INTO `admin_operation_log` VALUES (32, 1, 'huo15-admin', 'GET', '127.0.0.1', '[]', '2018-07-29 16:00:18', '2018-07-29 16:00:18');
INSERT INTO `admin_operation_log` VALUES (33, 1, 'huo15-admin/auth/logout', 'GET', '127.0.0.1', '{\"_pjax\":\"#pjax-container\"}', '2018-07-29 16:00:31', '2018-07-29 16:00:31');
INSERT INTO `admin_operation_log` VALUES (34, 1, 'huo15-admin', 'GET', '127.0.0.1', '[]', '2018-07-29 16:00:34', '2018-07-29 16:00:34');
COMMIT;

-- ----------------------------
-- Table structure for admin_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_permissions`;
CREATE TABLE `admin_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `http_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `http_path` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_permissions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_permissions
-- ----------------------------
BEGIN;
INSERT INTO `admin_permissions` VALUES (1, 'All permission', '*', '', '*', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (2, 'Dashboard', 'dashboard', 'GET', '/', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (3, 'Login', 'auth.login', '', '/auth/login\r\n/auth/logout', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (4, 'User setting', 'auth.setting', 'GET,PUT', '/auth/setting', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (5, 'Auth management', 'auth.management', '', '/auth/roles\r\n/auth/permissions\r\n/auth/menu\r\n/auth/logs', NULL, NULL);
INSERT INTO `admin_permissions` VALUES (6, 'Admin Config', 'ext.config', NULL, '/config*', '2018-07-29 15:48:38', '2018-07-29 15:48:38');
COMMIT;

-- ----------------------------
-- Table structure for admin_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_menu`;
CREATE TABLE `admin_role_menu` (
  `role_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_role_menu_role_id_menu_id_index` (`role_id`,`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `admin_role_menu` VALUES (1, 2, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for admin_role_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_permissions`;
CREATE TABLE `admin_role_permissions` (
  `role_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_role_permissions_role_id_permission_id_index` (`role_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_role_permissions
-- ----------------------------
BEGIN;
INSERT INTO `admin_role_permissions` VALUES (1, 1, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for admin_role_users
-- ----------------------------
DROP TABLE IF EXISTS `admin_role_users`;
CREATE TABLE `admin_role_users` (
  `role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_role_users_role_id_user_id_index` (`role_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_role_users
-- ----------------------------
BEGIN;
INSERT INTO `admin_role_users` VALUES (1, 1, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for admin_roles
-- ----------------------------
DROP TABLE IF EXISTS `admin_roles`;
CREATE TABLE `admin_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_roles
-- ----------------------------
BEGIN;
INSERT INTO `admin_roles` VALUES (1, 'Administrator', 'administrator', '2018-07-29 07:07:17', '2018-07-29 07:07:17');
COMMIT;

-- ----------------------------
-- Table structure for admin_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `admin_user_permissions`;
CREATE TABLE `admin_user_permissions` (
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `admin_user_permissions_user_id_permission_id_index` (`user_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for admin_users
-- ----------------------------
DROP TABLE IF EXISTS `admin_users`;
CREATE TABLE `admin_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admin_users_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of admin_users
-- ----------------------------
BEGIN;
INSERT INTO `admin_users` VALUES (1, 'admin', '$2y$10$ui14kgnlhAxtFLHNsZ.IoOsA6T6STBf15ThI8vkorC9U2Tf77GEQi', 'Administrator', 'images/372973f8e03aa40f5130b2d841c94913.png', 'TLHkAq9Pgi4Gl5wSqmMFnxjPylbr6ZiHRMBSRmxwjVC8oDJm4LBQFAtBqUq9', '2018-07-29 07:07:17', '2018-07-29 15:53:29');
COMMIT;

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of migrations
-- ----------------------------
BEGIN;
INSERT INTO `migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (2, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO `migrations` VALUES (3, '2016_01_04_173148_create_admin_tables', 1);
INSERT INTO `migrations` VALUES (4, '2017_07_17_040159_create_config_table', 2);
COMMIT;

-- ----------------------------
-- Table structure for password_resets
-- ----------------------------
DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;
